CREATE TABLE [dbo].[FS_Student_Bak]
(
[fdStudNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdSchoolPlace] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudPwd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudSchoolID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudSchool] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudCollegeID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudCollege] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudSpecID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudSpec] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudHomeTel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudPhone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudAddress] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudPost] [varchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdHealth] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdSex] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdSexID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdPolitics] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdPoliticsID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdLongevity] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdLongevityID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdTrainID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdTrain] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdNationID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdNation] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdPlace] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdPlaceID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudYearInt] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudYearOut] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudMethod] [int] NOT NULL,
[fdStudSelfCon] [bit] NOT NULL,
[fdStudCollCon] [bit] NOT NULL,
[fdStudAdmiCon] [bit] NOT NULL,
[fdStudBarCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudLoginIP] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudLoginAt] [datetime] NULL,
[fdStudIDCard] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudTrainUnit] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudNote] [text] COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdStudType] [int] NOT NULL,
[fdEmplyStatus] [int] NOT NULL,
[fdYear] [int] NOT NULL,
[fdGo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__FS_Student__fdGo__2E46C4CB] DEFAULT ('未就业'),
[fdIsReceive] [bit] NULL CONSTRAINT [DF_FS_Student_Bak_fdIsReceive] DEFAULT ((1))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
